Supported data types

The following table shows the Google Cloud BigQuery database target data types that are supported when using Qlik Replicate and the default mapping from Qlik Replicate data types.

For information on how to view the data type that is mapped from the source, see the section for the source database you are using. For additional information about Qlik Replicate data types, see Replicate data types.

Qlik Replicate and Google Cloud BigQuery database data types
Qlik ReplicateData Types	Google Cloud BigQuery database data types
BYTES	BYTES
DATE	DATE
TIME	TIME
DATETIME	If fraction <=6: TIMESTAMP If fraction >6: STRING
INT1	INTEGER
INT2	INTEGER
INT4	INTEGER
INT8	INTEGER
NUMERIC	If the data can be stored in 38,9, then: NUMERIC If not, then: STRING with length of original precision +2.
REAL4	FLOAT
REAL8	FLOAT
STRING	STRING
UINT1	INTEGER
UINT2	INTEGER
UINT4	INTEGER
UINT8	INTEGER
WSTRING	STRING
BLOB	BYTES
NCLOB	STRING
CLOB	STRING
BOOLEAN	BOOLEAN

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here